<?
if (!check_perms("users_mod")) {
    error(404);
}
Text::$TOC = true;
define('QUESTIONS_PER_PAGE', 25);
list($Page, $Limit) = Format::page_limit(QUESTIONS_PER_PAGE);

$DB->query("
		SELECT
			uq.ID,
			uq.Question,
			uq.UserID,
			uq.Date,
			(
				SELECT COUNT(1)
				FROM staff_answers AS sa
				WHERE sa.QuestionID = uq.ID
			) AS Responses
		FROM user_questions AS uq
		WHERE uq.ID NOT IN
				(
					SELECT siq.QuestionID
					FROM staff_ignored_questions AS siq
					WHERE siq.UserID = '$LoggedUser[ID]'
				)
			AND uq.ID NOT IN
				(
					SELECT sq.QuestionID
					FROM staff_answers AS sq
					WHERE sq.UserID = '$LoggedUser[ID]'
				)
		ORDER BY uq.Date DESC
		LIMIT $Limit");
$Questions = $DB->to_array();

$DB->query("
	SELECT COUNT(1)
	FROM user_questions");
list($TotalQuestions) = $DB->next_record();

View::show_header('Ask the Staff', 'questions,bbcode', 'PageQuestionHome');
if ($TotalQuestions > QUESTIONS_PER_PAGE) { ?>
    <div class="BodyNavLinks">
        <?
        $Pages = Format::get_pages($Page, $TotalQuestions, QUESTIONS_PER_PAGE);
        echo $Pages; ?>
    </div>
<? } ?>
<div class="LayoutBody">
    <div class="BodyHeader">
        <h2 class="BodyHeader-nav">User Questions</h2>
        <h3><?= number_format($TotalQuestions) ?> questions asked; <?= number_format(count($Questions)) ?> left to answer</h3>
    </div>
    <div class="BodyNavLinks">
        <a class="brackets" href="questions.php?action=answers">View staff answers</a>
        <a class="brackets" href="questions.php?action=popular_questions">Popular questions</a>
    </div>
    <? foreach ($Questions as $Question) { ?>
        <div id="question<?= $Question['ID'] ?>" class="box box2">
            <div class="head">
                <span>
                    <a class="post_id" href="questions.php#question<?= $Question['ID'] ?>">#<?= $Question['ID'] ?></a>
                    <?= Users::format_username($Question['UserID']) ?> - <?= time_diff($Question['Date']) ?>
                </span>
                <span style="float: right;">
                    <? if ($Question['Responses'] > 0) { ?>
                        <a href="#" id="<?= $Question['ID'] ?>" class="view_responses brackets"><?= $Question['Responses'] == 1 ? ("View " . $Question['Responses'] . " response") : ("View " . $Question['Responses'] . " responses") ?></a>
                        -
                    <?              } ?>
                    <form class="hidden" id="delete_<?= $Question['ID'] ?>" method="post" action="">
                        <input type="hidden" name="action" value="take_remove_question" />
                        <input type="hidden" name="auth" value="<?= $LoggedUser['AuthKey'] ?>" />
                        <input type="hidden" name="question_id" value="<?= $Question['ID'] ?>" />
                    </form>
                    <a href="#" onclick="if (confirm('Are you sure?') == true) { $('#delete_<?= $Question['ID'] ?>').raw().submit(); } return false;" class="brackets">Delete</a>
                    -
                    <a href="#" id="<?= $Question['ID'] ?>" class="brackets ignore_link">Ignore</a>
                    -
                    <a href="#" id="<?= $Question['ID'] ?>" class="answer_link brackets">Answer</a>
                </span>
            </div>
            <div class="pad HtmlText">
                <?= Text::full_format($Question['Question']) ?>
            </div>
        </div>
        <div class="Box">
            <div class="Box-body hidden center" id="answer<?= $Question['ID'] ?>">
                <? new TEXTAREA_PREVIEW("replybox_" . $Question['ID'], "replybox_" . $Question['ID'], '', 40, 8); ?>
                <input class="Button" type="submit" id="<?= $Question['ID'] ?>" value="Answer" />
            </div>
        </div>
    <?  } ?>
</div>
<?
View::show_footer();
